﻿CREATE TABLE [cex].[ContentNode] (
    [Id]                 INT              IDENTITY (1, 1) NOT NULL,
    [SiteId]             INT              NOT NULL,
    [NodeGuid]           UNIQUEIDENTIFIER NOT NULL,
    [Name]               VARCHAR (100)    NULL,
    [DisplayName]        VARCHAR (100)    NULL,
    [TemplateId]         INT              NOT NULL,
    [Summary]            VARCHAR (2000)   NULL,
    [Notes]              NVARCHAR (2000)  NULL,
    [CreatedDateTime]    DATETIME         NOT NULL,
    [PublishFrom]        DATETIME         NULL,
    [PublishTo]          DATETIME         NULL,
    [RequiresPublishing] BIT              NOT NULL,
    [ReadyToPublish]     BIT              NOT NULL,
    [DeveloperLocked]    BIT              NOT NULL,
    [Deleted]            BIT              NOT NULL,
    [CID]                TIMESTAMP        NOT NULL
);

